from sqlalchemy import Column, Integer, String, Text, Boolean, Date, DateTime, Time, BigInteger, Numeric, Float
from core.base.orm_model import Base


class CaseQc(Base):
    __tablename__ = "case_qc"

    id = Column(Integer, primary_key=True, nullable=False, comment="序号")
    case_id = Column(Integer, nullable=False, comment="案情id")
    project_id = Column(Integer, comment="项目id")
    qctype = Column(String(50), nullable=False, comment="案情质量类型")
    qcseq = Column(String(50), nullable=False, comment="案情质量序号")
    name = Column(String(100), nullable=False, comment="案情质量名称")
    sort = Column(Integer, comment="排序")
    options = Column(String(1), comment="选项 默认N 选择Y/N")
    score = Column(Numeric, comment="得分 默认0")
    created_by = Column(String(50), comment="创建人")
    created_dept = Column(String(100), comment="创建部门")
    remark = Column(Text, comment="备注说明")
